Repair Data

Data Review

head(RepairData)

##                  CreatedDate YearMonth UnitNumber      VMRS JobType UnitType
## 1 2015-01-02 00:00:00.000   2015-01     08I005     13-61       L      08I
## 2    2015-01-02 00:00:00.000   2015-01     08I005     13-61       L      08I
## 3    2015-01-02 00:00:00.000   2015-01     08I005     07-61       L      08I
## 4    2015-01-02 00:00:00.000   2015-01     08I005     07-61       L      08I
## 5    2015-01-02 00:00:00.000   2015-01     08I005 70-61-000       L      08I
## 6    2015-01-02 00:00:00.000   2015-01     08I005 70-61-000       L      08I
##   Vendor                                    RepairNotes Ext_Cost Parts_Cost
## 1   NULL                REPAIR/MODIF BOOM & COMPONENTS         0          0
## 2   NULL                REPAIR/MODIF BOOM & COMPONENTS         0          0
## 3   NULL                   LUBRICATE BOOM & COMPONENTS         0          0
## 4   NULL                   LUBRICATE BOOM & COMPONENTS         0          0
## 5   NULL PERFORM BOOM & COMPONENTS PIKE BOOM INSPECTION        0          0
## 6   NULL PERFORM BOOM & COMPONENTS PIKE BOOM INSPECTION        0          0
##   Labor_Hours     DateMY
## 1        2.72 2015-01-01
## 2        0.00 2015-01-01
## 3        1.12 2015-01-01
## 4        0.00 2015-01-01
## 5        3.27 2015-01-01
## 6        0.00 2015-01-01

The data elements in this set are:

• Created Date: Date repair was entered into fleetwave
• MonthYear: Fiscal Month and Year of the repair
• Unit Number: Pike Unit Number
• VMRS: Code for work done
• JobType: Part, Labor, or Commercial (External Work)
• UnitType: Specifics of Unit
• Vendor: If commercial, who did the work
• RepairNotes: Details of the VMRS
• Ext_Cost: Cost from commercial work
• Parts_Cost: Cost for purchases parts
• Labor_Hours: Hours of work by Pike Mechanics, hours are used to normalize costing structure
• DateMY: Fiscal Month and Year in date format

Trends

We’ll start by taking a look at the data trends over the past years in the 3 Job Type categories, and turning MonthYear into date data

## # A tibble: 6 x 5
##   YearMonth  ExtCost PartsCost LaborCost GraphName    
##   <chr>        <dbl>     <dbl>     <dbl> <chr>        
## 1 2015-01   1178927.   324719.  2155102. January 2015 
## 2 2015-02   1520721.   420885.  2906847  February 2015
## 3 2015-03   2069592.   478191.  3730920  March 2015   
## 4 2015-04   1455493.   375864.  2509432. April 2015   
## 5 2015-05   2044913.   420283.  3061500  May 2015     
## 6 2015-06   2414304.   553826.  3527547  June 2015

Vendor Details

Seeing the increase in Extended Cost, lets dig into the top 20 vendors from 2018 to 2020 to see the delta over the past few years.

## # A tibble: 20 x 2
##    Vendor                                 ExtCost
##    <chr>                                    <dbl>
##  1 ALTEC INDUSTRIES INC.                31322943.
##  2 REPAIR CENTRAL LLC                   22621281.
##  3 BRIDGESTONE AMERICAS TIRE OPERATIONS  8521351.
##  4 MISCELLANEOUS VENDOR                  6772268.
##  5 FORD QUALITY FLEET CARE               2806376.
##  6 GMFLEETTRAC PROCESSING CENTER         2744641.
##  7 RUSH TRUCK CENTERS OF TEXAS           2469541.
##  8 SOUTHERN TIRE MART LLC                2396538.
##  9 FLEET CHARGE                          1164497.
## 10 JAMES RIVER EQUIPMENT-CHARLOTTE       1115563.
## 11 GOODYEAR TIRE & RUBBER CO              803480.
## 12 NAPA 01709                             783636.
## 13 TSE INTERNATIONAL INC                  708575.
## 14 KENWOOD USA CORP COMM-LAND MOB         673399.
## 15 SAFELITE GLASS CORP                    636720.
## 16 JIFFY LUBE 2738 WAKE FOREST NC         626094.
## 17 GLOBAL RENTAL CO INC                   624192.
## 18 VERMEER SOUTHEAST SALES                585779.
## 19 TEREX GLOBAL GMBH                      575038.
## 20 RECHTIEN INTERNATIONAL-FLEET           561723.

Now, we can take a look at the trends that each of the top 20 vendors went through over the past 3 years.

The chart highlights the growth of Altec and Repair Central in comparison to all other vendors. The second chart is a cleaner look with all other vendors lumped into All Others. But when we look at all vendors, we can see there is a general growth from all major external vendors over the past 3 years.